package com.hisense.ovcloud.spark.sql.config;

public class Conf {
    public final static String DATA_SOURCE_BIGDATA = "bigdata";
    public final static String INSERT_ACTION_TYPE = "1";

    public final static long TIME_DIFF_THRESHOLD_SECONDS = 3600 * 1000;
    public final static String PAIR_END_TIME_SLOT = "2999-12-31 23:59:59";

    public final static String DeviceSupportFeatureCode = "INSERT INTO device_support_featurecode (devicetype, featurecode, power, wator, origin, update_time) VALUES (?,?,?,?,?,UTC_TIMESTAMP()) ON DUPLICATE KEY UPDATE devicetype=values(devicetype), featurecode=values(featurecode), power=values(power), wator=values(wator), origin=values(origin), update_time=UTC_TIMESTAMP()";
    public final static String DeviceSupportPuid = "INSERT INTO device_support_puid (puid, devicetype, featurecode, power, wator, update_time) VALUES (?, ?,?,?,?,UTC_TIMESTAMP()) ON DUPLICATE KEY UPDATE puid=values(puid), devicetype=values(devicetype), featurecode=values(featurecode), power=values(power), wator=values(wator), update_time=UTC_TIMESTAMP()";

    public static class Origin {
        public final static String CHINA = "1";
        public final static String OVERSEA = "2";
        public final static String OTHERS = "3";
    }
}
